﻿CREATE PROCEDURE [dbo].[uspt_ip_init_sns]
AS
    DECLARE @id UNIQUEIDENTIFIER

    -- QQ

    SET @id = CONVERT(UNIQUEIDENTIFIER, '{A721E517-A50A-4634-8815-22AA9484815B}')
    EXEC uspt_ip_create_or_update_sns
        @id = @id,
        @login_name = 'weizhou',
        @login_password = '123',
        @nickname = N'周巍'

    SET @id = CONVERT(UNIQUEIDENTIFIER, '{A45D7069-A623-4654-9F5F-72EC24CB6554}')
    EXEC uspt_ip_create_or_update_sns
        @id = @id,
        @login_name = 'qq1',
        @login_password = '123',
        @nickname = N'QQ用户1'

    SET @id = CONVERT(UNIQUEIDENTIFIER, '{39A65283-805C-4B28-915C-981626C81A12}')
    EXEC uspt_ip_create_or_update_sns
        @id = @id,
        @login_name = 'qq2',
        @login_password = '123',
        @nickname = N'QQ用户2'

    SET @id = CONVERT(UNIQUEIDENTIFIER, '{93F3A9B2-B544-4D85-A2E7-E04DD6836935}')
    EXEC uspt_ip_create_or_update_sns
        @id = @id,
        @login_name = 'qq3',
        @login_password = '123',
        @nickname = N'QQ用户3'

    -- SINA

    --SET @id = CONVERT(UNIQUEIDENTIFIER, '{4D868101-F0BC-4E68-B62E-B08C9DA01BC2}')
    --EXEC uspt_ip_create_or_update_sns
    --    @id = @id,
    --    @login_name = 'lvleiyan',
    --    @login_password = '123',
    --    @nickname = N'吕雷燕'

    SET @id = CONVERT(UNIQUEIDENTIFIER, '{706F001D-AD62-420C-928F-02737045E735}')
    EXEC uspt_ip_create_or_update_sns
        @id = @id,
        @login_name = 'sina1',
        @login_password = '123',
        @nickname = N'新浪用户1'

    SET @id = CONVERT(UNIQUEIDENTIFIER, '{A16E67D1-2B43-44DE-BC97-65EBDA5FCD13}')
    EXEC uspt_ip_create_or_update_sns
        @id = @id,
        @login_name = 'sina2',
        @login_password = '123',
        @nickname = N'新浪用户2'

    SET @id = CONVERT(UNIQUEIDENTIFIER, '{C6144AC6-B1B4-4F26-8D38-5CBD15232575}')
    EXEC uspt_ip_create_or_update_sns
        @id = @id,
        @login_name = 'sina3',
        @login_password = '123',
        @nickname = N'新浪用户3'

    -- WeiXin

    --SET @id = CONVERT(UNIQUEIDENTIFIER, '{3241DFC0-CAB2-41EE-8EA9-052C552D0B0A}')
    --EXEC uspt_ip_create_or_update_sns
    --    @id = @id,
    --    @login_name = 'jiyanqin',
    --    @login_password = '123',
    --    @nickname = N'季艳琴'

    SET @id = CONVERT(UNIQUEIDENTIFIER, '{AA03B2EE-B081-47CD-B11F-1B036F73BB58}')
    EXEC uspt_ip_create_or_update_sns
        @id = @id,
        @login_name = 'weixin1',
        @login_password = '123',
        @nickname = N'微信用户1'

    SET @id = CONVERT(UNIQUEIDENTIFIER, '{6865016E-0746-4C53-9A54-B0A7AEFF5563}')
    EXEC uspt_ip_create_or_update_sns
        @id = @id,
        @login_name = 'weixin2',
        @login_password = '123',
        @nickname = N'微信用户2'

    SET @id = CONVERT(UNIQUEIDENTIFIER, '{B0B376D9-9108-484C-A7EA-C7CD339215A8}')
    EXEC uspt_ip_create_or_update_sns
        @id = @id,
        @login_name = 'weixin3',
        @login_password = '123',
        @nickname = N'微信用户3'

RETURN 0
